home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Database / Foxpro 2.06 Win / STEP3.QP_ / STEP3.bin
Encoding:
Text File  |  1994-03-11  |  310 b   |  9 lines
  1. SELECT OFFICES.CITY, SALESMAN.ONO, INVOICES.SALESMAN, SALESMAN.NAME,;
  2.   SUM(INVOICES.ITOTAL);
  3.  FROM INVOICES, SALESMAN, OFFICES;
  4.  WHERE SALESMAN.SALESMAN = INVOICES.SALESMAN;
  5.    AND OFFICES.ONO = SALESMAN.ONO;
  6.  GROUP BY SALESMAN.ONO, INVOICES.SALESMAN;
  7.  INTO CURSOR STEP3
  8. REPORT FORM STEP3.FRX PREVIEW
  9.